CREATE TABLE [dbo].[Bill_Property](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[FName] [varchar](200) NOT NULL,
	[FCid] [int] NULL,
	[FCName] [varchar](50) NULL,
	[FDate] [datetime] NOT NULL,
	[FRDate] [datetime] NOT NULL DEFAULT GETDATE(),
	[FBillNo] [varchar](50) NOT NULL,
	[FVerifyCode] [varchar](50) NOT NULL,
	[FUid] [int] NOT NULL,
	[FUName] [varchar](50) NOT NULL,
	[FVid] [int] NULL,
	[FVName] [varchar](50) NULL,
	[FItem1] [varchar](100) NULL,
	[FSDate1] [datetime] NULL,
	[FEDate1] [datetime] NULL,
	[FQty1] [decimal](18, 2) NULL,
	[FDays1] [decimal](18, 2) NULL,
	[FPrice1] [decimal](18, 2) NULL,
	[FAcc1] [decimal](18, 2) NULL,
	[FItem2] [varchar](100) NULL,
	[FSDate2] [datetime] NULL,
	[FEDate2] [datetime] NULL,
	[FQty2] [decimal](18, 2) NULL,
	[FDays2] [decimal](18, 2) NULL,
	[FPrice2] [decimal](18, 2) NULL,
	[FAcc2] [decimal](18, 2) NULL,
	[FItem3] [varchar](100) NULL,
	[FSDate3] [datetime] NULL,
	[FEDate3] [datetime] NULL,
	[FQty3] [decimal](18, 2) NULL,
	[FDays3] [decimal](18, 2) NULL,
	[FPrice3] [decimal](18, 2) NULL,
	[FAcc3] [decimal](18, 2) NULL,
	[FItem4] [varchar](100) NULL,
	[FSDate4] [datetime] NULL,
	[FEDate4] [datetime] NULL,
	[FQty4] [decimal](18, 2) NULL,
	[FDays4] [decimal](18, 2) NULL,
	[FPrice4] [decimal](18, 2) NULL,
	[FAcc4] [decimal](18, 2) NULL,
	[FAmount] [decimal](18, 2) NULL,
	[FCancel] [int] NOT NULL DEFAULT 0,
	[FPCount] [int] NOT NULL DEFAULT 0,
	[FBCode] [varchar](30)
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE dbo.Bill_Property ADD CONSTRAINT
	PK_Bill_Property PRIMARY KEY CLUSTERED 
	(
	id,
	FBillNo
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO